package com.hooya.fa.eu.biz.dao.mapper;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hooya.fa.eu.biz.dao.entity.dto.StoreCorpDTO;
import com.hooya.fa.eu.biz.dao.entity.rxh.MetaStore;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lzw
 * @since 2025-09-11
 */
@Mapper
public interface MetaStoreMapper extends BaseMapper<MetaStore> {

    @Select("SELECT DISTINCT store, SUBSTRING_INDEX(LOWER(corp), '-', 1) corp FROM fa_eu.meta_store WHERE corp <> ''")
    List<StoreCorpDTO> getStoreAndCorp();


}
